Tabela LServicePriceList

Definicja tabeli LServicePriceList

Name

LServicePriceList

Code

LServicePriceList

Comment

PL: Przyporzadkowanie cennika dla uslugi.
Wyznacza cennik dla uslugi (nawet surowej, nie bedacej jeszcze opcja)
EN: Assignement service to a price list


Lista kolumn tabeli LServicePriceList

Name

Code

PriceListID

PriceListID

ServID

ServID

Price

Price

PriceFrom

PriceFrom

PriceTo

PriceTo

Advance

Advance

CodeInPriceList

CodeInPriceList

NameInPriceList

NameInPriceList

Notes

Notes

CalculationStrategyId

CalculationStrategyId

PriceForSAKPRO

PriceForSAKPRO


Kolumna PriceListID tabeli LServicePriceList

Definicja kolumny PriceListID tabeli LServicePriceList

Name

PriceListID

Code

PriceListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli LServicePriceList

Definicja kolumny ServID tabeli LServicePriceList

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Price tabeli LServicePriceList

Definicja kolumny Price tabeli LServicePriceList

Name

Price

Code

Price

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna PriceFrom tabeli LServicePriceList

Definicja kolumny PriceFrom tabeli LServicePriceList

Name

PriceFrom

Code

PriceFrom

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna PriceTo tabeli LServicePriceList

Definicja kolumny PriceTo tabeli LServicePriceList

Name

PriceTo

Code

PriceTo

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna Advance tabeli LServicePriceList

Definicja kolumny Advance tabeli LServicePriceList

Name

Advance

Code

Advance

Data Type

NUMBER(10,2)

Mandatory

No

Comment

Kwota zaliczki wymaganej przed wykonaniem danej uslugi (wizyta)


Kolumna CodeInPriceList tabeli LServicePriceList

Definicja kolumny CodeInPriceList tabeli LServicePriceList

Name

CodeInPriceList

Code

CodeInPriceList

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna NameInPriceList tabeli LServicePriceList

Definicja kolumny NameInPriceList tabeli LServicePriceList

Name

NameInPriceList

Code

NameInPriceList

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Notes tabeli LServicePriceList

Definicja kolumny Notes tabeli LServicePriceList

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CalculationStrategyId tabeli LServicePriceList

Definicja kolumny CalculationStrategyId tabeli LServicePriceList

Name

CalculationStrategyId

Code

CalculationStrategyId

Data Type

NUMBER(10)

Mandatory

No

Comment

Wartosc w tej kolumnie bedzie wskazywala jaki rodzaj strategi wyliczania ceny ma byc uzyty dla danego profilu


Kolumna PriceForSAKPRO tabeli LServicePriceList

Definicja kolumny PriceForSAKPRO tabeli LServicePriceList

Name

PriceForSAKPRO

Code

PriceForSAKPRO

Data Type

FLOAT

Mandatory

No

Comment

Kolumna wirtualna cast(price as float)


Lista kluczy tabeli LServicePriceList

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServicePriceList

Definicja klucza Identifier_1 tabeli LServicePriceList

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment